﻿SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON

GO


CREATE PROCEDURE [dbo].[bhp_temp_ModBlogStructure]
AS
BEGIN

	DECLARE
		@PostsGroupId		INT
		
	SELECT @PostsGroupId = id FROM n_Tree WHERE name = 'BLOG_POSTS' AND parent = 0
	
	
	
	UPDATE
		bht_GroupExtensions
	SET
		GroupExtension = 'blackhouse.NemoBlog.Web.PostGroupExtension,blackhouse.NemoBlog.Web'
	WHERE
		GroupId = @PostsGroupId
	
		
END
GO

EXEC [bhp_temp_ModBlogStructure]
GO

DROP PROCEDURE [bhp_temp_ModBlogStructure]